﻿
SET DATEFORMAT ymd
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('1', NULL, '60', 6, NULL, '0', 1, 1, '部门', '', 0)
GO
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('10', NULL, '1', 6, NULL, '0', 1, 1, '加班请假单', '', 0)
GO
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('11', NULL, '90', 6, NULL, '0', 1, 1, '批量补出勤', '', 0)
GO
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('12', NULL, '10', 6, NULL, '0', 1, 1, '系统基础数据', NULL, 0)
GO
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('2', NULL, '40', 6, NULL, '0', 1, 1, '门', '', 0)
GO
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('3', NULL, '50', 6, NULL, '0', 1, 1, '设备', '', 0)
GO
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('4', NULL, '70', 6, NULL, '0', 1, 1, '班次', '', 0)
GO
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('5', NULL, '80', 6, NULL, '0', 1, 1, '批量请假单', '', 0)
GO
INSERT INTO dbo.bd_sys_codeRule(classId, identifyCode, prefix, length, suffix, fill, codeType, increment, remark, curDate, curValue) VALUES('6', NULL, '10', 6, NULL, '0', 1, 1, '班次与部门配置展示表', '', 0)
GO
